package com.the4man.framework.model.gen;

import java.util.ArrayList;
import java.util.List;

/**
 * Created by lenovo on 2017/12/11.
 */
public class DeviceExampleBase {
    protected String orderByClause;
    protected boolean distinct;
    protected List<Criteria> oredCriteria = new ArrayList();
    protected int limitStart = -1;
    protected int rowsPerPage = -1;

    public DeviceExampleBase() {
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return this.orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return this.distinct;
    }

    public List<DeviceExampleBase.Criteria> getOredCriteria() {
        return this.oredCriteria;
    }

    public void or(DeviceExampleBase.Criteria criteria) {
        this.oredCriteria.add(criteria);
    }

    public DeviceExampleBase.Criteria or() {
        DeviceExampleBase.Criteria criteria = this.createCriteriaInternal();
        this.oredCriteria.add(criteria);
        return criteria;
    }

    public DeviceExampleBase.Criteria createCriteria() {
        DeviceExampleBase.Criteria criteria = this.createCriteriaInternal();
        if(this.oredCriteria.size() == 0) {
            this.oredCriteria.add(criteria);
        }

        return criteria;
    }

    protected DeviceExampleBase.Criteria createCriteriaInternal() {
        DeviceExampleBase.Criteria criteria = new DeviceExampleBase.Criteria();
        return criteria;
    }

    public void clear() {
        this.oredCriteria.clear();
        this.orderByClause = null;
        this.distinct = false;
    }

    public void setLimitStart(int limitStart) {
        this.limitStart = limitStart;
    }

    public int getLimitStart() {
        return this.limitStart;
    }

    public void setRowsPerPage(int rowsPerPage) {
        this.rowsPerPage = rowsPerPage;
    }

    public int getRowsPerPage() {
        return this.rowsPerPage;
    }

    public static class Criteria extends DeviceExampleBase.GeneratedCriteria {
        protected Criteria() {
        }
    }

    public static class Criterion {
        private String condition;
        private Object value;
        private Object secondValue;
        private boolean noValue;
        private boolean singleValue;
        private boolean betweenValue;
        private boolean listValue;
        private String typeHandler;

        public String getCondition() {
            return this.condition;
        }

        public Object getValue() {
            return this.value;
        }

        public Object getSecondValue() {
            return this.secondValue;
        }

        public boolean isNoValue() {
            return this.noValue;
        }

        public boolean isSingleValue() {
            return this.singleValue;
        }

        public boolean isBetweenValue() {
            return this.betweenValue;
        }

        public boolean isListValue() {
            return this.listValue;
        }

        public String getTypeHandler() {
            return this.typeHandler;
        }

        protected Criterion(String condition) {
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if(value instanceof List) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }

        }

        protected Criterion(String condition, Object value) {
            this(condition, value, (String)null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, (String)null);
        }
    }

    protected abstract static class GeneratedCriteria {
        protected List<DeviceExampleBase.Criterion> criteria = new ArrayList();

        protected GeneratedCriteria() {
        }

        public boolean isValid() {
            return this.criteria.size() > 0;
        }

        public List<DeviceExampleBase.Criterion> getAllCriteria() {
            return this.criteria;
        }

        public List<DeviceExampleBase.Criterion> getCriteria() {
            return this.criteria;
        }

        protected void addCriterion(String condition) {
            if(condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            } else {
                this.criteria.add(new DeviceExampleBase.Criterion(condition));
            }
        }

        protected void addCriterion(String condition, Object value, String property) {
            if(value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            } else {
                this.criteria.add(new DeviceExampleBase.Criterion(condition, value));
            }
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if(value1 != null && value2 != null) {
                this.criteria.add(new DeviceExampleBase.Criterion(condition, value1, value2));
            } else {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
        }

        public DeviceExampleBase.Criteria andNotBindDevice() {
            this.addCriterion("id not in (select dev_id from employee_device)");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andExistBindDevice(String empId) {
            this.addCriterion("id in (select dev_id from employee_device where emp_id = '" + empId + "')");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andIdIsNull() {
            this.addCriterion("id is null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andIdIsNotNull() {
            this.addCriterion("id is not null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andIdEqualTo(String value) {
            this.addCriterion("id =", value, "id");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andIdNotEqualTo(String value) {
            this.addCriterion("id <>", value, "id");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andIdGreaterThan(String value) {
            this.addCriterion("id >", value, "id");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andIdGreaterThanOrEqualTo(String value) {
            this.addCriterion("id >=", value, "id");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andIdLessThan(String value) {
            this.addCriterion("id <", value, "id");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andIdLessThanOrEqualTo(String value) {
            this.addCriterion("id <=", value, "id");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andIdLike(String value) {
            this.addCriterion("id like", value, "id");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andIdNotLike(String value) {
            this.addCriterion("id not like", value, "id");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andIdIn(List<String> values) {
            this.addCriterion("id in", values, "id");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andIdNotIn(List<String> values) {
            this.addCriterion("id not in", values, "id");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andIdBetween(String value1, String value2) {
            this.addCriterion("id between", value1, value2, "id");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andIdNotBetween(String value1, String value2) {
            this.addCriterion("id not between", value1, value2, "id");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andHardwareNoIsNull() {
            this.addCriterion("hardware_no is null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andHardwareNoIsNotNull() {
            this.addCriterion("hardware_no is not null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andHardwareNoEqualTo(String value) {
            this.addCriterion("hardware_no =", value, "hardwareNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andHardwareNoNotEqualTo(String value) {
            this.addCriterion("hardware_no <>", value, "hardwareNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andHardwareNoGreaterThan(String value) {
            this.addCriterion("hardware_no >", value, "hardwareNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andHardwareNoGreaterThanOrEqualTo(String value) {
            this.addCriterion("hardware_no >=", value, "hardwareNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andHardwareNoLessThan(String value) {
            this.addCriterion("hardware_no <", value, "hardwareNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andHardwareNoLessThanOrEqualTo(String value) {
            this.addCriterion("hardware_no <=", value, "hardwareNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andHardwareNoLike(String value) {
            this.addCriterion("hardware_no like", value, "hardwareNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andHardwareNoNotLike(String value) {
            this.addCriterion("hardware_no not like", value, "hardwareNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andHardwareNoIn(List<String> values) {
            this.addCriterion("hardware_no in", values, "hardwareNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andHardwareNoNotIn(List<String> values) {
            this.addCriterion("hardware_no not in", values, "hardwareNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andHardwareNoBetween(String value1, String value2) {
            this.addCriterion("hardware_no between", value1, value2, "hardwareNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andHardwareNoNotBetween(String value1, String value2) {
            this.addCriterion("hardware_no not between", value1, value2, "hardwareNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCardNumIsNull() {
            this.addCriterion("cardNum is null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCardNumIsNotNull() {
            this.addCriterion("cardNum is not null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCardNumEqualTo(String value) {
            this.addCriterion("cardNum =", value, "cardNum");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCardNumNotEqualTo(String value) {
            this.addCriterion("cardNum <>", value, "cardNum");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCardNumGreaterThan(String value) {
            this.addCriterion("cardNum >", value, "cardNum");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCardNumGreaterThanOrEqualTo(String value) {
            this.addCriterion("cardNum >=", value, "cardNum");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCardNumLessThan(String value) {
            this.addCriterion("cardNum <", value, "cardNum");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCardNumLessThanOrEqualTo(String value) {
            this.addCriterion("cardNum <=", value, "cardNum");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCardNumLike(String value) {
            this.addCriterion("cardNum like", value, "cardNum");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCardNumNotLike(String value) {
            this.addCriterion("cardNum not like", value, "cardNum");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCardNumIn(List<String> values) {
            this.addCriterion("cardNum in", values, "cardNum");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCardNumNotIn(List<String> values) {
            this.addCriterion("cardNum not in", values, "cardNum");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCardNumBetween(String value1, String value2) {
            this.addCriterion("cardNum between", value1, value2, "cardNum");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCardNumNotBetween(String value1, String value2) {
            this.addCriterion("cardNum not between", value1, value2, "cardNum");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceNoIsNull() {
            this.addCriterion("device_no is null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceNoIsNotNull() {
            this.addCriterion("device_no is not null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceNoEqualTo(String value) {
            this.addCriterion("device_no =", value, "deviceNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceNoNotEqualTo(String value) {
            this.addCriterion("device_no <>", value, "deviceNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceNoGreaterThan(String value) {
            this.addCriterion("device_no >", value, "deviceNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceNoGreaterThanOrEqualTo(String value) {
            this.addCriterion("device_no >=", value, "deviceNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceNoLessThan(String value) {
            this.addCriterion("device_no <", value, "deviceNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceNoLessThanOrEqualTo(String value) {
            this.addCriterion("device_no <=", value, "deviceNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceNoLike(String value) {
            this.addCriterion("device_no like", value, "deviceNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceNoNotLike(String value) {
            this.addCriterion("device_no not like", value, "deviceNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceNoIn(List<String> values) {
            this.addCriterion("device_no in", values, "deviceNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceNoNotIn(List<String> values) {
            this.addCriterion("device_no not in", values, "deviceNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceNoBetween(String value1, String value2) {
            this.addCriterion("device_no between", value1, value2, "deviceNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceNoNotBetween(String value1, String value2) {
            this.addCriterion("device_no not between", value1, value2, "deviceNo");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceTypeIsNull() {
            this.addCriterion("device_type is null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceTypeIsNotNull() {
            this.addCriterion("device_type is not null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceTypeEqualTo(String value) {
            this.addCriterion("device_type =", value, "deviceType");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceTypeNotEqualTo(String value) {
            this.addCriterion("device_type <>", value, "deviceType");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceTypeGreaterThan(String value) {
            this.addCriterion("device_type >", value, "deviceType");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceTypeGreaterThanOrEqualTo(String value) {
            this.addCriterion("device_type >=", value, "deviceType");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceTypeLessThan(String value) {
            this.addCriterion("device_type <", value, "deviceType");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceTypeLessThanOrEqualTo(String value) {
            this.addCriterion("device_type <=", value, "deviceType");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceTypeLike(String value) {
            this.addCriterion("device_type like", value, "deviceType");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceTypeNotLike(String value) {
            this.addCriterion("device_type not like", value, "deviceType");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceTypeIn(List<String> values) {
            this.addCriterion("device_type in", values, "deviceType");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceTypeNotIn(List<String> values) {
            this.addCriterion("device_type not in", values, "deviceType");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceTypeBetween(String value1, String value2) {
            this.addCriterion("device_type between", value1, value2, "deviceType");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceTypeNotBetween(String value1, String value2) {
            this.addCriterion("device_type not between", value1, value2, "deviceType");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateTimeIsNull() {
            this.addCriterion("create_time is null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateTimeIsNotNull() {
            this.addCriterion("create_time is not null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateTimeEqualTo(String value) {
            this.addCriterion("create_time =", value, "createTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateTimeNotEqualTo(String value) {
            this.addCriterion("create_time <>", value, "createTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateTimeGreaterThan(String value) {
            this.addCriterion("create_time >", value, "createTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateTimeGreaterThanOrEqualTo(String value) {
            this.addCriterion("create_time >=", value, "createTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateTimeLessThan(String value) {
            this.addCriterion("create_time <", value, "createTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateTimeLessThanOrEqualTo(String value) {
            this.addCriterion("create_time <=", value, "createTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateTimeLike(String value) {
            this.addCriterion("create_time like", value, "createTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateTimeNotLike(String value) {
            this.addCriterion("create_time not like", value, "createTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateTimeIn(List<String> values) {
            this.addCriterion("create_time in", values, "createTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateTimeNotIn(List<String> values) {
            this.addCriterion("create_time not in", values, "createTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateTimeBetween(String value1, String value2) {
            this.addCriterion("create_time between", value1, value2, "createTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateTimeNotBetween(String value1, String value2) {
            this.addCriterion("create_time not between", value1, value2, "createTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateUserIsNull() {
            this.addCriterion("create_user is null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateUserIsNotNull() {
            this.addCriterion("create_user is not null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateUserEqualTo(String value) {
            this.addCriterion("create_user =", value, "createUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateUserNotEqualTo(String value) {
            this.addCriterion("create_user <>", value, "createUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateUserGreaterThan(String value) {
            this.addCriterion("create_user >", value, "createUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            this.addCriterion("create_user >=", value, "createUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateUserLessThan(String value) {
            this.addCriterion("create_user <", value, "createUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateUserLessThanOrEqualTo(String value) {
            this.addCriterion("create_user <=", value, "createUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateUserLike(String value) {
            this.addCriterion("create_user like", value, "createUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateUserNotLike(String value) {
            this.addCriterion("create_user not like", value, "createUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateUserIn(List<String> values) {
            this.addCriterion("create_user in", values, "createUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateUserNotIn(List<String> values) {
            this.addCriterion("create_user not in", values, "createUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateUserBetween(String value1, String value2) {
            this.addCriterion("create_user between", value1, value2, "createUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCreateUserNotBetween(String value1, String value2) {
            this.addCriterion("create_user not between", value1, value2, "createUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateTimeIsNull() {
            this.addCriterion("update_time is null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateTimeIsNotNull() {
            this.addCriterion("update_time is not null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateTimeEqualTo(String value) {
            this.addCriterion("update_time =", value, "updateTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateTimeNotEqualTo(String value) {
            this.addCriterion("update_time <>", value, "updateTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateTimeGreaterThan(String value) {
            this.addCriterion("update_time >", value, "updateTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateTimeGreaterThanOrEqualTo(String value) {
            this.addCriterion("update_time >=", value, "updateTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateTimeLessThan(String value) {
            this.addCriterion("update_time <", value, "updateTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateTimeLessThanOrEqualTo(String value) {
            this.addCriterion("update_time <=", value, "updateTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateTimeLike(String value) {
            this.addCriterion("update_time like", value, "updateTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateTimeNotLike(String value) {
            this.addCriterion("update_time not like", value, "updateTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateTimeIn(List<String> values) {
            this.addCriterion("update_time in", values, "updateTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateTimeNotIn(List<String> values) {
            this.addCriterion("update_time not in", values, "updateTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateTimeBetween(String value1, String value2) {
            this.addCriterion("update_time between", value1, value2, "updateTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateTimeNotBetween(String value1, String value2) {
            this.addCriterion("update_time not between", value1, value2, "updateTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateUserIsNull() {
            this.addCriterion("update_user is null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateUserIsNotNull() {
            this.addCriterion("update_user is not null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateUserEqualTo(String value) {
            this.addCriterion("update_user =", value, "updateUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateUserNotEqualTo(String value) {
            this.addCriterion("update_user <>", value, "updateUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateUserGreaterThan(String value) {
            this.addCriterion("update_user >", value, "updateUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            this.addCriterion("update_user >=", value, "updateUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateUserLessThan(String value) {
            this.addCriterion("update_user <", value, "updateUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateUserLessThanOrEqualTo(String value) {
            this.addCriterion("update_user <=", value, "updateUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateUserLike(String value) {
            this.addCriterion("update_user like", value, "updateUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateUserNotLike(String value) {
            this.addCriterion("update_user not like", value, "updateUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateUserIn(List<String> values) {
            this.addCriterion("update_user in", values, "updateUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateUserNotIn(List<String> values) {
            this.addCriterion("update_user not in", values, "updateUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateUserBetween(String value1, String value2) {
            this.addCriterion("update_user between", value1, value2, "updateUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andUpdateUserNotBetween(String value1, String value2) {
            this.addCriterion("update_user not between", value1, value2, "updateUser");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCurrStatusIsNull() {
            this.addCriterion("curr_status is null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCurrStatusIsNotNull() {
            this.addCriterion("curr_status is not null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCurrStatusEqualTo(Integer value) {
            this.addCriterion("curr_status =", value, "currStatus");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCurrStatusNotEqualTo(Integer value) {
            this.addCriterion("curr_status <>", value, "currStatus");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCurrStatusGreaterThan(Integer value) {
            this.addCriterion("curr_status >", value, "currStatus");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCurrStatusGreaterThanOrEqualTo(Integer value) {
            this.addCriterion("curr_status >=", value, "currStatus");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCurrStatusLessThan(Integer value) {
            this.addCriterion("curr_status <", value, "currStatus");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCurrStatusLessThanOrEqualTo(Integer value) {
            this.addCriterion("curr_status <=", value, "currStatus");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCurrStatusIn(List<Integer> values) {
            this.addCriterion("curr_status in", values, "currStatus");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCurrStatusNotIn(List<Integer> values) {
            this.addCriterion("curr_status not in", values, "currStatus");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCurrStatusBetween(Integer value1, Integer value2) {
            this.addCriterion("curr_status between", value1, value2, "currStatus");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andCurrStatusNotBetween(Integer value1, Integer value2) {
            this.addCriterion("curr_status not between", value1, value2, "currStatus");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andRegisterTimeIsNull() {
            this.addCriterion("register_time is null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andRegisterTimeIsNotNull() {
            this.addCriterion("register_time is not null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andRegisterTimeEqualTo(String value) {
            this.addCriterion("register_time =", value, "registerTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andRegisterTimeNotEqualTo(String value) {
            this.addCriterion("register_time <>", value, "registerTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andRegisterTimeGreaterThan(String value) {
            this.addCriterion("register_time >", value, "registerTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andRegisterTimeGreaterThanOrEqualTo(String value) {
            this.addCriterion("register_time >=", value, "registerTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andRegisterTimeLessThan(String value) {
            this.addCriterion("register_time <", value, "registerTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andRegisterTimeLessThanOrEqualTo(String value) {
            this.addCriterion("register_time <=", value, "registerTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andRegisterTimeLike(String value) {
            this.addCriterion("register_time like", value, "registerTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andRegisterTimeNotLike(String value) {
            this.addCriterion("register_time not like", value, "registerTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andRegisterTimeIn(List<String> values) {
            this.addCriterion("register_time in", values, "registerTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andRegisterTimeNotIn(List<String> values) {
            this.addCriterion("register_time not in", values, "registerTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andRegisterTimeBetween(String value1, String value2) {
            this.addCriterion("register_time between", value1, value2, "registerTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andRegisterTimeNotBetween(String value1, String value2) {
            this.addCriterion("register_time not between", value1, value2, "registerTime");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceStateIsNull() {
            this.addCriterion("device_State is null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceStateIsNotNull() {
            this.addCriterion("device_State is not null");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceStateEqualTo(Integer value) {
            this.addCriterion("device_State =", value, "deviceState");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceStateNotEqualTo(Integer value) {
            this.addCriterion("device_State <>", value, "deviceState");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceStateGreaterThan(Integer value) {
            this.addCriterion("device_State >", value, "deviceState");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceStateGreaterThanOrEqualTo(Integer value) {
            this.addCriterion("device_State >=", value, "deviceState");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceStateLessThan(Integer value) {
            this.addCriterion("device_State <", value, "deviceState");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceStateLessThanOrEqualTo(Integer value) {
            this.addCriterion("device_State <=", value, "deviceState");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceStateIn(List<Integer> values) {
            this.addCriterion("device_State in", values, "deviceState");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceStateNotIn(List<Integer> values) {
            this.addCriterion("device_State not in", values, "deviceState");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceStateBetween(Integer value1, Integer value2) {
            this.addCriterion("device_State between", value1, value2, "deviceState");
            return (DeviceExampleBase.Criteria)this;
        }

        public DeviceExampleBase.Criteria andDeviceStateNotBetween(Integer value1, Integer value2) {
            this.addCriterion("device_State not between", value1, value2, "deviceState");
            return (DeviceExampleBase.Criteria)this;
        }
    }
}
